package com.ynny.jdbc01;

import com.mysql.cj.jdbc.Driver;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;

public class JDBCDemo05 {


    public static void main(String[] args) throws SQLException {

        Driver driver = new Driver();
        DriverManager.registerDriver(driver);
        String url = "jdbc:mysql://localhost:3306/db01";
        String userName = "root";
        String password = "root";
        Connection connection = DriverManager
                .getConnection(url, userName, password);


        //写sql
        //占位符 赋值
        String sql = "update book set name = ? where id = ?";
        //4.准备一个PreparedStatement对象 装载运输SQL语句到数据库中
        PreparedStatement preparedStatement =
                connection.prepareStatement(sql);
        //4.1给占位符赋值
        preparedStatement.setString(1,"累羊羊");
        preparedStatement.setString(2,"10");

        //5.执行sql语句  ---->查询用的是 executeQuery()
        //               --->修改 添加 删除 executeUpdate();
        int i = preparedStatement.executeUpdate();


        System.out.println(i);
        //6.关闭资源

        preparedStatement.close();
        connection.close();



    }
}
